2014-10-10 - 14991 - Break Fix - SNC Inbound Delivery Creation Multiple PO for Single SO #ProductionBreakFix #SNCProject #ABAPSNC

2014-10-10 - 14991 - SNC - Inbound Delivery Creation Changes for Multiple POs for one Sales order.

Problem Summary

Inbound Delivery Creation changes.

Admin Info

Purpose
 Inbound Delivery Creation Program Changes
Requested by
 Rahul Attarde
Spec Created By
 Adithya Vojjal
Spec Created Date
 10/10/2014
Spec QA by
 Adithya Vojjal
Objects
Document Status
 Complete

Estimates

Sl.No
 Activity
 Estimation in Hours
1
 Research
 08
2
 Documentation
 20
3
 Development/ Config
 40
4
 Unit test in DEV
 32
5
 Unit test in QUA
 40
6
 Other activity

TOTAL
 140

References

Prior Tickets

[Provide links of prior associated Spec / Break Fix BOSS document(s)]

Documents

[Attach any document(s) received for the requirement(s)]

NA

Spec Changes

Sl.
 Change Details
 Requested By
 Requested On
 Notes if any










Functional Requirement

Purpose/WHY:

[Explain the purpose of the project and the reason why this requirement has come]

Purpose:

Currently Inbound Delivery Creation Program creates one Inbound Delivery for one sales order, even if the Multiple Purchase Orders are created for that one sales order.
Change the Inbound Delivery Creation Program to create a Inbound Delivery for one sales order of that specific Purchase order, if the same sales order is maintained in another purchase order create another sales order for that Sales order.
Below is the Example which shows the requirement in Detail:
Sales order
 SO Item
 Purchase Order
 PO Item
 Inb Delivery
67762
 10
 4600007221
 10
 180001241
20
 4600007219
 10
 180001240
30
 4600007219
 20
 180001240
40
 4600007219
 30
 180001240
50
 4600007220
 10
 180001242
60
 4600007220
 20
 180001242

The above example shows that two Purchase Orders are created for a single sales order. The requirement is to create two Inbound Deliveries (Each one for one PO).

Consider the Sales Orders in that PO and Create one Inbound Delivery for one Sales Order of that Particular PO.

Why:

As we know Multiple Purchase orders are created for one Sales Order. Though ZN is updated and sewing is complete, Inbound Deliveries are not created for few lines of the PO as all lines corresponding to that SO is not updated by ZN (few lines of the SO are in other PO).

NE requested to consider SO only from that PO and create the Inbound Delivery

Note:

This Changes have an Impact on all the SNC Objects; Such as:
1. Packing.
2. Small Package File.
3. PGR - Invoice Freight Price Update in Sales Order (For those Inbound Deliveries which are having Incoterm as PPI).
4. ASN form Inbound Delivery (IDoc and email).
5. Pack Slip.

Packing:

If Multiple Inbound Deliveries are created for a Single sales order there is a discrepancy in Packing.All the corresponding deliveries for a Single SO are considered as single delivery and wrong HU's numbering is happening for the inbound deliveries and packing them wrongly.These HU's should be generated separately for each inbound delivery though they are related to a single SO.

Below are the test scenarios for the Single SO's and multiple inbound deliveries for standard, case lot and cross dock orders
S.No
 Test Scenario
 Pack codes that are maintained in the SO's
 Expected result
1
 1.Create Single SO with multiple items with relevant pack codes and save the order.
2.Create two PO's for the multiple items and corresponding inbound deliveries.
3.Pack the inbound deliveries.
 a.P01 and P04
b.P02 and P06
c.P19 and P07
d.Without any pack codes
 The inbound deliveries are packed with the respective pack codes i from the SO.
2
 1.Create two SO's with multiple items with relevant pack codes and save the orders.
2.Create Single PO for the two sales orders and corresponding inbound deliveries.
3.Pack the inbound deliveries.
 a.P01 and P04
b.P02 and P06
c.P19 and P07
d.Without any pack codes
 The inbound deliveries are packed with the respective packcodes from the SO.
3
 1.Create Single SO with multiple items with relevant pack codes and save the order.
2.Create single PO for the multiple items and corresponding inbound delivery.
3.Pack the inbound delivery.
 a.P01 and P04
b.P02 and P06
c.P19 and P07
d.Without any pack codes
 The inbound deliveries are packed with the respective packcodes from the SO.
4
 1.Create Single Caselot SO with multiple items with relevant pack codes and caselot ID text and save the order.
2.Create two PO's for the multiple items and corresponding inbound deliveries.
3.Pack the inbound deliveries.
 a.P16
b.P17
c.P18
 The inbound deliveries are packed with the respective packcodes and the from the SO.
5
 1.Create two Caselot SO's with multiple items with relevant pack codes and caselot ID text and save the orders.
2.Create Single PO for the two sales orders and corresponding inbound deliveries.
3.Pack the inbound deliveries.
 a.P16
b.P17
c.P18
 The inbound deliveries are packed with the respective packcodes and the from the SO.
6
 1.Create Single Caselot SO with multiple items with relevant pack codes,caselot ID text and save the order.
2.Create single PO for the multiple items and corresponding inbound delivery.
3.Pack the inbound delivery.
 a.P16
b.P17
c.P18
 The inbound deliveries are packed with the respective packcodes and the from the SO.
7
 1.Create Single Crossdock SO with multiple items and caselot ID text and save the order.
2.Create two PO's for the multiple items and corresponding inbound deliveries.
3.Pack the inbound deliveries.
 a.with Run size ratio - 1 - 15 (pack by 1W)
b.with Run size ratio - 16 - 30 (pack by 2W)
c.with Run size ratio - 31 - 45 (pack by 3W)
 The inbound deliveries are packed with the respective packcodes and the from the SO.
8
 1.Create two Crossdock SO's with multiple items and caselot ID text and save the orders.
2.Create Single PO for the two sales orders and corresponding inbound deliveries.
3.Pack the inbound deliveries.
 a.with Run size ratio - 1 - 15 (pack by 1W)
b.with Run size ratio - 16 - 30 (pack by 2W)
c.with Run size ratio - 31 - 45 (pack by 3W)
 The inbound deliveries are packed with the respective packcodes and the from the SO.
9
 1.Create Single Crossdock SO with multiple items and caselot ID text and save the order.
2.Create single PO for the multiple items and corresponding inbound delivery.
3.Pack the inbound delivery.
 a.with Run size ratio - 1 - 15 (pack by 1W)
b.with Run size ratio - 16 - 30 (pack by 2W)
c.with Run size ratio - 31 - 45 (pack by 3W)
 The inbound deliveries are packed with the respective packcodes and the from the SO.
Below are the test scenarios for the single SO and Single Inbound deliveries.

Sl. No
 Test Scenario
 Testing Program
 Expected Results
1
 Pass one delivery through packing program
 China Outbound & Inbound
 Packing done based on Pack By and Max Box Size from Delivery
2
 Pass multiple deliveries through packing program
 China Outbound & Inbound
 Packing done based on Pack By and Max Box Size from Delivery and each delivery IDOC is processed individually
3
 Pack with Alternate UOM 1 CAR = 9 EA
 China Outbound & Inbound
 Max number of caps in 1W is 9
4
 Pack with Alternate UOM 1 CAR = 10 EA
 China Outbound & Inbound
 Max number of caps in 1W is 10
5
 Pack with Alternate UOM 1 CAR = 7 EA
 China Outbound & Inbound
 Max number of caps in 1W is 7
6
 Create sales order with just pre-pack materials (P12, P6) using PPP code
 China Outbound & Inbound
 Correct number of handling units created based on quantity ordered
7
 Create sales order with pre-packs and EA's using PPP code
 China Outbound & Inbound
 Packing program errors and delivery is not updated
8
 Create sales order with just EA's using PPP code
 China Outbound & Inbound
 Packing program errors and delivery is not updated
9
 Create sales order with just EA's using PPP code
 China Outbound & Inbound
 Packing program errors and delivery is not updated
10
 Crossdock with run size ratio between 1 - 15
 China Outbound & Inbound
 Pack by 1W
11
 Crossdock with run size ratio between 16 – 30
 China Outbound & Inbound
 Pack by 2W
12
 Crossdock with run size ratio between 31 – 45
 China Outbound & Inbound
 Pack by 3W
13
 Caselot specifying max box size 1W
 China Outbound & Inbound
 Pack by 1W
14
 Caselot specifying max box size 4W
 China Outbound & Inbound
 Pack by 4W
15
 Caselot specifying max box size 6W
 China Outbound & Inbound
 Pack by 6W
16
 Caselot without specifying max box size
 China Outbound & Inbound
 Correct error message displayed
17
 Crossdock with incorrect quantities to run size ratio
 China Outbound & Inbound
 Correct error message displayed
18
 Caselot with incorrect quantities to run size ratio
 China Outbound & Inbound
 Correct error message displayed
19
 Crossdock with text in language other than EN
 China Outbound & Inbound
 Pack based on size run and appropriate max box size
20
 Caselot with text in language other than EN
 China Outbound & Inbound
 Pack based on size run and appropriate max box size
21
 Create sales order with P* UOM without any P codes
 China Outbound & Inbound
 Should default to 6W and pack mixed and created correct number of handling units based on quantities
22
 Create sales order with mixed P* UOM without any P codes
 China Outbound & Inbound
 Should default to 6W and pack mixed and created correct number of handling units based on quantities
23
 Create sales order with mixed P* and EA UOM without any P codes
 China Outbound & Inbound
 Should default to 6W and pack mixed and created correct number of handling units based on quantities
24
 Create sales order with EA UOM without any P codes
 China Outbound & Inbound
 Should default to 6W and pack mixed and created correct All number of handling units based on quantities
25
 Create an order that is pack mixed with a material that has an Alternate UOM and material that doesn't have Alternate UOM.
 China Outbound & Inbound
 All non-alternate UOM materials are pack mixed, while any materials with alternate UOM is packed by family – remaining inner cartons are combined into max box size
26
 Pack with EA UOM using 1W, 2W, 3W, 4W, 6W, 10W and 12W with random Pack By Family or Sku per line item all in same sales order – no alt UOM
 China Outbound & Inbound
 Each line item packed individually based on max box size and pack by
27
 Pack with P* UOM using 1W, 2W, 3W, 4W, 6W,10W and 12W with random Pack By Family or Sku per line item all in same sales order – no alt UOM
 China Outbound & Inbound
 Each line item packed individually based on max box size and pack by
28
 Pack with mixed EA and P* UOM using 1W, 2W, 3W, 4W, 6W, 10W and 12W with random Pack By Family or Sku per line item all in same sales order – no alt UOM
 China Outbound & Inbound
 Each line item packed individually based on max box size and pack by
29
 Pack with EA UOM using 1W, 2W, 3W, 4W, 6W, 10W and 12W with random Pack By Family or Sku per line item all in same sales order – with some alt UOM
 China Outbound & Inbound
 Each line item packed individually based on alternate UOM, max box size and pack by
30
 Pack Mixed with EA UOM with 1W
 China Outbound & Inbound
 Pack mixed into 1W
31
 Pack Mixed with P* UOM with 2W
 China Outbound & Inbound
 Pack mixed into 2W – remaining inner cartons combined into max box size
32
 Pack Mixed with EA and P* UOM with 3W
 China Outbound & Inbound
 Pack mixed into 3W – remaining inner cartons combined into max box size
33
 Pack Mixed with EA UOM with 4W
 China Outbound & Inbound
 Pack mixed into 4W – remaining inner cartons combined into max box size
34
 Pack Mixed with P* UOM with 6W
 China Outbound & Inbound
 Pack mixed into 6W – remaining inner cartons combined into max box size
35
 Pack Mixed with EA and P* UOM with 10W
 China Outbound & Inbound
 Pack mixed into 10W – remaining inner cartons combined into max box size
36
 Pack Mixed with EA and P* UOM with 12W
 China Outbound & Inbound
 Pack mixed into 12W – remaining inner cartons combined into max box size
37
 Pack by SKU / Size without defining max box size
 China Outbound & Inbound
 Pack by sku with max box size 6W
38
 Pack by Material / Family without defining max box size
 China Outbound & Inbound
 Pack by family with max box size 6W
39
 Mixed Pack with without defining max box size
 China Outbound & Inbound
 Pack mixed with max box size 6W
40
 SSCC handling unit should be unique per box
 China Outbound & Inbound
 Ensure SSCC numbers are unique for each record
41
 Run packing manually at the same time job runs
 China Outbound & Inbound
 Ensure SSCC numbers are not duplicated
42
 Cross dock scenario with 1-15,16-30,31- 45 to Pack 1W,2W and 3W respectively.
 China Outbound & Inbound
 Each item should be packed as per their run size ratio
43
 Pass two deliveries through FM and program one delivery with no alternate UOM and one with some Alternate UOM
 China Outbound & Inbound
 The delivery with no Alternate UOM should not be packed by the Alternate UOM of another delivery.
44
 Get list of deliveries including Outbound and Inbound that meet China delivery selection criteria and make sure they are packed after the first batch job is run
 China Outbound & Inbound
 After first batch job is run, no deliveries matching the selection criteria should exist
45
 Create PO from Sales order with more than 100 line items
 China Outbound & Inbound
 To test the performance of the programs
46
 Multiple sales orders in a single PO
 China Outbound & Inbound
 For each sales order in a PO , individual Delivery has to be created

Small Package File:


When a small package file is been generated for the list of POs for which there is one Sales Order, one single Inbound Delivery is repeated for all the items of the Sales order.

Test Scenarios:
S. No.
 Test Scenario
1
 One sales order 4 POs and 3 Inbound deliveries out of which 1 is Unpacked and for one PO no Inbound Delivery
2
 One Sales order one Po and One Inbound Delivery
3
 Three Sales Orders distributed few line items to Three Purchase Orders, With Inco terms in the sales orders as CBC, TPB and ROU


PGR:

When PGR is Happened and when the Incoterm in Inb Delivery is PPI, ZFRE is updated in the SO (sum of all lines in the file) but if multiple inbound deliveries are there for a single sales order ZFRE is updated multiple times in the sales order. ZFRE is the header condition type. When Invoice is carried out on that Sales order price in the first ZFRE Condition is only considered and triggered in the invoice.

Solution:
Need to think how we have to update the freight price. This is to be solved in an other Ticket.

ASN:


ASN

In Scope:

[List the activities to be included in scope]
Inbound Delivery for Third Party Purchase orders are only considered,

Out of Scope:

[Out of scope activities]
Quick Turn Orders are out of the Scope, For Quick Turn Orders only one Purchase order is created for a sales order.
Normal NB Purchase Orders are also out of scope.


This is under Analysis and discussion and currently Put in to HOLD

2. Changes Discussed on 07-08-2014
Currently Inbound Delivery is created for Third Party (Z3NB) Purchase Orders, One Inbound Delivery is created for one sales order.
Please review the initial spec for inbound delivery creation.
Additional to the logic of one Inbound Delivery for one sales order, the program should also consider the Delivery Date of the Purchase Order.
For Eg:
If a Purchase Order has 6 Line Items: 4 line Items with one Sales Order and Other two with another sales order.
Po
 Item
 Sales Order
 SO Item
 Delivery Date
 Notes
4600045678
 10
 34567
 10
 06/21/2014
 One Inbound Delivery for the Delivery Date 06/21/2014
4600045678
 20
 34567
 20
 06/21/2014
 One Inbound Delivery for the Delivery Date 06/21/2014
4600045678
 30
 34567
 30
 07/09/2014
 One Inbound Delivery for the Delivery Date 07/09/2014
4600045678
 40
 34567
 40
 07/09/2014
 One Inbound Delivery for the Delivery Date 07/09/2014
4600045678
 50
 34568
 10
 07/09/2014
 One Inbound Delivery for the Delivery Date 07/09/2014
4600045678
 60
 34568
 20
 07/09/2014
 One Inbound Delivery for the Delivery Date 07/09/2014

Solution Analysis and Recommendations

(Include Screen Shots if required)
1. Change the Inbound Delivery Program and the other related programs too.

Resolution

Changes to the program.

Release Information

Provide link here to Release Notes if Technical Objects were changed